0

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.6101319789886 397 1.1464 0


No Amazon API Requests Made.


App Debug - Total Time 1.6101319789886 seconds

Number Time From Start Name Description
1 0.37540078163147 Initialise Initialise FSB Function
2 0.37848997116089 App Controller Start Start of the App controller (called before the controller of every page)
3 0.42526292800903 Start of getCategoryListByGroup Function Before first category groups query
4 0.4260528087616 After initial query Before first category groups query
5 0.4260528087616 Get Category List for Group Before the call to getCategoryList function
6 0.42605590820312 Start of GetCategoryList function Start of the function
7 0.42605781555176 Before getting categories Query to get specific category list
8 0.42677688598633 After getting categories Query to get specific category list
9 0.42677783966064 Before getting category custom Before call to function getCategoryCustom
10 0.44102787971497 After getting category custom After call to function getCategoryCustom
11 0.44102883338928 Before getting category custom Before call to function getCategoryCustom
12 0.44927382469177 After getting category custom After call to function getCategoryCustom
13 0.44927477836609 Before getting category custom Before call to function getCategoryCustom
14 0.45387697219849 After getting category custom After call to function getCategoryCustom
15 0.4538779258728 Before getting category custom Before call to function getCategoryCustom
16 0.4568498134613 After getting category custom After call to function getCategoryCustom
17 0.45685076713562 Before getting category custom Before call to function getCategoryCustom
18 0.45976090431213 After getting category custom After call to function getCategoryCustom
19 0.45976185798645 Before getting category custom Before call to function getCategoryCustom
20 0.46265482902527 After getting category custom After call to function getCategoryCustom
21 0.46265697479248 End of GetCategoryList function End of the function
22 0.46265983581543 Get Category List for Group Before the call to getCategoryList function
23 0.46266078948975 Start of GetCategoryList function Start of the function
24 0.46266198158264 Before getting categories Query to get specific category list
25 0.4629909992218 End of getCategoryListByGroup Function Before return()
26 1.2529208660126 App Controller End End of the App controller (called before the controller of every page)
27 1.4431917667389 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.4450588226318 Before Get Options Before the call to getOptions in the tpl class
29 1.5170209407806 After Get Options After the call to getOptions in the tpl class
30 1.5170559883118 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.6101229190826 Finalizing debug Before the debug is output to the page.
32 1.6101307868958 End of App This is the end of the app logging, final timestamp


Query Debug - 397 Database Queries. Total time 1.1464 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0015 0.0015208721160889
SELECT parameter, value FROM parameters
2 0.0025 0.0024728775024414
SELECT * FROM `bad_bots`
3 0.0002 0.00023007392883301
SET time_zone = 'Europe/London'
4 0.0018 0.001798152923584
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0023 0.002277135848999
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.195\";}'
6 0.0013 0.0013058185577393
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1751845796'
7 0.0018 0.0017688274383545
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00045394897460938
UPDATE autorun SET lastrun = '2025-07-06 23:49:56' WHERE id = '13'
9 0.0005 0.00052905082702637
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0015 0.0014820098876953
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
11 0.0004 0.0003809928894043
SELECT * FROM pages WHERE id = 52
12 0.0032 0.0032260417938232
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0427 0.042731046676636
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0004 0.00041484832763672
SELECT * FROM pages WHERE pagename = 'search'
15 0.0008 0.00078392028808594
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0007 0.00070500373840332
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0054 0.0054171085357666
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
18 0.0008 0.00083017349243164
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0006 0.00058412551879883
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0003 0.00028491020202637
SELECT id FROM categories WHERE parent_id = '26'
21 0.0046 0.004594087600708
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
22 0.0008 0.00079202651977539
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
23 0.0008 0.00076913833618164
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
24 0.0006 0.00064992904663086
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0003 0.00028395652770996
SELECT * FROM categorygroups WHERE id = '1'
26 0.0030 0.0030241012573242
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27 0.0004 0.00035500526428223
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0003 0.00026607513427734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0003 0.00029897689819336
SELECT id FROM categories WHERE parent_id = '27'
30 0.0030 0.0030238628387451
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
31 0.0003 0.00032806396484375
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
32 0.0003 0.00034689903259277
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0003 0.00030207633972168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0003 0.0002751350402832
SELECT * FROM categorygroups WHERE id = '1'
35 0.0011 0.0010888576507568
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0003 0.00029587745666504
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0003 0.00026297569274902
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0003 0.00027990341186523
SELECT id FROM categories WHERE parent_id = '28'
39 0.0013 0.0013391971588135
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
40 0.0003 0.00033402442932129
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
41 0.0004 0.00037813186645508
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
42 0.0003 0.00030803680419922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0003 0.00029897689819336
SELECT * FROM categorygroups WHERE id = '1'
44 0.0004 0.00038599967956543
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45 0.0003 0.00029611587524414
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0003 0.0002739429473877
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0003 0.0002892017364502
SELECT id FROM categories WHERE parent_id = '29'
48 0.0004 0.00044488906860352
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
49 0.0003 0.00034999847412109
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
50 0.0003 0.00033092498779297
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0003 0.00029897689819336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0003 0.0002899169921875
SELECT * FROM categorygroups WHERE id = '1'
53 0.0004 0.00037789344787598
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0003 0.00029897689819336
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0003 0.00026202201843262
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0003 0.00028204917907715
SELECT id FROM categories WHERE parent_id = '30'
57 0.0004 0.00043010711669922
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
58 0.0003 0.00032806396484375
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
59 0.0003 0.00033807754516602
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
60 0.0003 0.00030112266540527
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0003 0.0002751350402832
SELECT * FROM categorygroups WHERE id = '1'
62 0.0004 0.00039005279541016
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0003 0.00029420852661133
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0003 0.00026202201843262
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0003 0.00027704238891602
SELECT id FROM categories WHERE parent_id = '31'
66 0.0005 0.00045013427734375
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
67 0.0003 0.00031018257141113
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
68 0.0003 0.00032401084899902
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0003 0.00029397010803223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0003 0.00027203559875488
SELECT * FROM categorygroups WHERE id = '1'
71 0.0003 0.00032687187194824
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0018 0.0017549991607666
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0007 0.0007481575012207
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0004 0.0003669261932373
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
75 0.0006 0.00059795379638672
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0009 0.0008690357208252
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0006 0.00055599212646484
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.7815 0.78154802322388
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.195') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.195') <= INET_ATON(ip_end)
79 0.0014 0.0014128684997559
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0006 0.00062108039855957
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0004 0.00036001205444336
SELECT * FROM pages WHERE pagename = 'search'
82 0.0048 0.0047540664672852
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
83 0.0014 0.0013749599456787
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0009 0.00089311599731445
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0047 0.0047018527984619
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
86 0.0015 0.0014650821685791
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0004 0.00042891502380371
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0010 0.00097799301147461
INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT 'easehold bote cafe hermetique botes et coffrets the et cafe', NOW(), '216.73.216.195'
89 0.0009 0.00090694427490234
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
90 0.0008 0.000823974609375
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
91 0.0042 0.0042350292205811
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE 'easehold') OR (keyfeatures LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (keyfeatures LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (keyfeatures LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (keyfeatures LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (keyfeatures LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (keyfeatures LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (keyfeatures LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (keyfeatures LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (keyfeatures LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (keyfeatures LIKE 'cafe') OR (title LIKE 'cafe'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
92 0.0004 0.00037813186645508
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (title LIKE 'cafe'))
		AND hide = 0
93 0.0007 0.00073409080505371
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (title LIKE 'cafe'))
		AND hide = 0
94 0.0003 0.00034093856811523
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
95 0.0164 0.016373157501221
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%easehold%') OR (keyfeatures LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (keyfeatures LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (keyfeatures LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (keyfeatures LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (keyfeatures LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (keyfeatures LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (keyfeatures LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (keyfeatures LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (keyfeatures LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (keyfeatures LIKE '%cafe%') OR (title LIKE '%cafe%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
96 0.0006 0.00057196617126465
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%'))
		AND hide = 0
97 0.0004 0.00043106079101562
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%'))
		AND hide = 0
98 0.0006 0.00064802169799805
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
99 0.0007 0.0006721019744873
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
100 0.0098 0.0097899436950684
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE 'easehold') OR (keyfeatures LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (keyfeatures LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (keyfeatures LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (keyfeatures LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (keyfeatures LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (keyfeatures LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (keyfeatures LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (keyfeatures LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (keyfeatures LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (keyfeatures LIKE 'cafe') OR (title LIKE 'cafe'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
101 0.0005 0.0004730224609375
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (title LIKE 'cafe'))
		AND hide = 0
102 0.0005 0.0004570484161377
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (title LIKE 'cafe'))
		AND hide = 0
103 0.0006 0.00064396858215332
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
104 0.0163 0.016334056854248
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%easehold%') OR (keyfeatures LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (keyfeatures LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (keyfeatures LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (keyfeatures LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (keyfeatures LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (keyfeatures LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (keyfeatures LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (keyfeatures LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (keyfeatures LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (keyfeatures LIKE '%cafe%') OR (title LIKE '%cafe%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
105 0.0004 0.00040411949157715
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%'))
		AND hide = 0
106 0.0004 0.00036787986755371
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%'))
		AND hide = 0
107 0.0004 0.00041389465332031
SELECT * FROM products WHERE id = '2020'
108 0.0015 0.0014629364013672
SELECT * FROM productimages WHERE product_id = '2020' ORDER BY sortorder ASC
109 0.0014 0.0014128684997559
SELECT * FROM product_image_select WHERE product_id = '2020'
110 0.0010 0.0010061264038086
SELECT * FROM productcustomimages WHERE product_id = '2020'
111 0.0019 0.0018711090087891
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2020' AND a.name = n.originalname
112 0.0013 0.0012698173522949
SELECT * FROM productoffers WHERE product_id = '2020' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0004 0.00041508674621582
SELECT * FROM productoffers
                WHERE product_id = '2020' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0003 0.00032305717468262
SELECT * FROM productoffers
                WHERE product_id = 2020
                ORDER BY price ASC LIMIT 1
115 0.0006 0.00057315826416016
SELECT value FROM productattributes
                WHERE product_id = '2020'
                AND name = 'ListPriceAmount'
116 0.0005 0.00049185752868652
SELECT value FROM productattributes WHERE product_id = '2020' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117 0.0005 0.00051593780517578
SELECT * FROM products WHERE id = '1147'
118 0.0005 0.00051522254943848
SELECT * FROM productimages WHERE product_id = '1147' ORDER BY sortorder ASC
119 0.0008 0.00075793266296387
SELECT * FROM product_image_select WHERE product_id = '1147'
120 0.0004 0.00038599967956543
SELECT * FROM productcustomimages WHERE product_id = '1147'
121 0.0009 0.00094294548034668
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1147' AND a.name = n.originalname
122 0.0005 0.00045585632324219
SELECT * FROM productoffers WHERE product_id = '1147' AND merchantid = 'A1X6FK5RDHNB96'
123 0.0004 0.00038313865661621
SELECT * FROM productoffers
                WHERE product_id = '1147' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0003 0.00030207633972168
SELECT * FROM productoffers
                WHERE product_id = 1147
                ORDER BY price ASC LIMIT 1
125 0.0003 0.00034189224243164
SELECT value FROM productattributes
                WHERE product_id = '1147'
                AND name = 'ListPriceAmount'
126 0.0004 0.00040888786315918
SELECT value FROM productattributes WHERE product_id = '1147' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0005 0.00049304962158203
SELECT * FROM products WHERE id = '913'
128 0.0005 0.00054192543029785
SELECT * FROM productimages WHERE product_id = '913' ORDER BY sortorder ASC
129 0.0008 0.00075483322143555
SELECT * FROM product_image_select WHERE product_id = '913'
130 0.0004 0.00041103363037109
SELECT * FROM productcustomimages WHERE product_id = '913'
131 0.0011 0.0010881423950195
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '913' AND a.name = n.originalname
132 0.0004 0.00043511390686035
SELECT * FROM productoffers WHERE product_id = '913' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0003 0.00033998489379883
SELECT * FROM productoffers
                WHERE product_id = '913' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0003 0.00030112266540527
SELECT * FROM productoffers
                WHERE product_id = 913
                ORDER BY price ASC LIMIT 1
135 0.0003 0.00032806396484375
SELECT value FROM productattributes
                WHERE product_id = '913'
                AND name = 'ListPriceAmount'
136 0.0004 0.00036311149597168
SELECT value FROM productattributes WHERE product_id = '913' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0005 0.00047111511230469
SELECT * FROM products WHERE id = '2867'
138 0.0006 0.00056982040405273
SELECT * FROM productimages WHERE product_id = '2867' ORDER BY sortorder ASC
139 0.0007 0.00073003768920898
SELECT * FROM product_image_select WHERE product_id = '2867'
140 0.0004 0.0003659725189209
SELECT * FROM productcustomimages WHERE product_id = '2867'
141 0.0012 0.001183032989502
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2867' AND a.name = n.originalname
142 0.0003 0.00029993057250977
SELECT * FROM productoffers WHERE product_id = '2867' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0002 0.00024604797363281
SELECT * FROM productoffers
                WHERE product_id = '2867' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0003 0.00025010108947754
SELECT value FROM productattributes WHERE product_id = '2867' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0003 0.0003058910369873
SELECT * FROM products WHERE id = '1627'
146 0.0003 0.00029993057250977
SELECT * FROM productimages WHERE product_id = '1627' ORDER BY sortorder ASC
147 0.0002 0.00024890899658203
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1627' AND p.id = pi.product_id ORDER BY pi.sortorder
148 0.0004 0.00041794776916504
SELECT * FROM product_image_select WHERE product_id = '1627'
149 0.0003 0.0002739429473877
SELECT * FROM productcustomimages WHERE product_id = '1627'
150 0.0003 0.00031399726867676
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1627'
                GROUP BY o.product_id
151 0.0013 0.0012869834899902
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1627'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
152 0.0003 0.00030303001403809
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1627
153 0.0006 0.00056910514831543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1627' AND a.name = n.originalname
154 0.0002 0.00023603439331055
SELECT * FROM productoffers WHERE product_id = '1627' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0002 0.00023293495178223
SELECT * FROM productoffers
                WHERE product_id = '1627' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = 1627
                ORDER BY price ASC LIMIT 1
157 0.0002 0.00022792816162109
SELECT value FROM productattributes
                WHERE product_id = '1627'
                AND name = 'ListPriceAmount'
158 0.0004 0.00037002563476562
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1627'
                GROUP BY o.product_id
159 0.0004 0.00043201446533203
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1627'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
160 0.0003 0.00031495094299316
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1627
161 0.0004 0.00044488906860352
SELECT value FROM productattributes WHERE product_id = '1627' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162 0.0012 0.0012271404266357
SELECT * FROM products WHERE parent_id = '1627'
163 0.0007 0.0007169246673584
SELECT * FROM products WHERE id = '3764'
164 0.0006 0.00056791305541992
SELECT * FROM productimages WHERE product_id = '3764' ORDER BY sortorder ASC
165 0.0009 0.00089287757873535
SELECT * FROM product_image_select WHERE product_id = '3764'
166 0.0005 0.00045585632324219
SELECT * FROM productcustomimages WHERE product_id = '3764'
167 0.0014 0.0014259815216064
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3764' AND a.name = n.originalname
168 0.0008 0.00076103210449219
SELECT * FROM productoffers WHERE product_id = '3764' AND merchantid = 'A1X6FK5RDHNB96'
169 0.0005 0.00049901008605957
SELECT * FROM productoffers
                WHERE product_id = '3764' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0004 0.00040507316589355
SELECT * FROM productoffers
                WHERE product_id = 3764
                ORDER BY price ASC LIMIT 1
171 0.0009 0.00087785720825195
SELECT value FROM productattributes
                WHERE product_id = '3764'
                AND name = 'ListPriceAmount'
172 0.0008 0.00080609321594238
SELECT value FROM productattributes WHERE product_id = '3764' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
173 0.0005 0.00052595138549805
SELECT * FROM products WHERE id = '3050'
174 0.0004 0.0004119873046875
SELECT * FROM productimages WHERE product_id = '3050' ORDER BY sortorder ASC
175 0.0006 0.00060319900512695
SELECT * FROM product_image_select WHERE product_id = '3050'
176 0.0004 0.00040292739868164
SELECT * FROM productcustomimages WHERE product_id = '3050'
177 0.0009 0.00087308883666992
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3050' AND a.name = n.originalname
178 0.0006 0.00056004524230957
SELECT * FROM productoffers WHERE product_id = '3050' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0004 0.00036406517028809
SELECT * FROM productoffers
                WHERE product_id = '3050' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0003 0.0003209114074707
SELECT value FROM productattributes WHERE product_id = '3050' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0004 0.00043702125549316
SELECT * FROM products WHERE id = '4609'
182 0.0004 0.00039815902709961
SELECT * FROM productimages WHERE product_id = '4609' ORDER BY sortorder ASC
183 0.0009 0.00088715553283691
SELECT * FROM product_image_select WHERE product_id = '4609'
184 0.0003 0.00029301643371582
SELECT * FROM productcustomimages WHERE product_id = '4609'
185 0.0006 0.00059795379638672
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4609' AND a.name = n.originalname
186 0.0003 0.00033807754516602
SELECT * FROM productoffers WHERE product_id = '4609' AND merchantid = 'A1X6FK5RDHNB96'
187 0.0003 0.00028109550476074
SELECT * FROM productoffers
                WHERE product_id = '4609' AND price > 0
                ORDER BY price ASC LIMIT 1
188 0.0003 0.00026893615722656
SELECT value FROM productattributes WHERE product_id = '4609' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
189 0.0003 0.00034403800964355
SELECT * FROM products WHERE id = '1063'
190 0.0003 0.00032806396484375
SELECT * FROM productimages WHERE product_id = '1063' ORDER BY sortorder ASC
191 0.0004 0.00043416023254395
SELECT * FROM product_image_select WHERE product_id = '1063'
192 0.0003 0.00028204917907715
SELECT * FROM productcustomimages WHERE product_id = '1063'
193 0.0006 0.00063514709472656
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1063' AND a.name = n.originalname
194 0.0003 0.00029182434082031
SELECT * FROM productoffers WHERE product_id = '1063' AND merchantid = 'A1X6FK5RDHNB96'
195 0.0002 0.00023198127746582
SELECT * FROM productoffers
                WHERE product_id = '1063' AND price > 0
                ORDER BY price ASC LIMIT 1
196 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = 1063
                ORDER BY price ASC LIMIT 1
197 0.0003 0.0002589225769043
SELECT value FROM productattributes
                WHERE product_id = '1063'
                AND name = 'ListPriceAmount'
198 0.0002 0.00024890899658203
SELECT value FROM productattributes WHERE product_id = '1063' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
199 0.0003 0.00034999847412109
SELECT * FROM products WHERE id = '1422'
200 0.0004 0.00035190582275391
SELECT * FROM productimages WHERE product_id = '1422' ORDER BY sortorder ASC
201 0.0004 0.00042891502380371
SELECT * FROM product_image_select WHERE product_id = '1422'
202 0.0003 0.00025200843811035
SELECT * FROM productcustomimages WHERE product_id = '1422'
203 0.0009 0.000885009765625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1422' AND a.name = n.originalname
204 0.0003 0.00031900405883789
SELECT * FROM productoffers WHERE product_id = '1422' AND merchantid = 'A1X6FK5RDHNB96'
205 0.0003 0.00025415420532227
SELECT * FROM productoffers
                WHERE product_id = '1422' AND price > 0
                ORDER BY price ASC LIMIT 1
206 0.0002 0.00024890899658203
SELECT value FROM productattributes WHERE product_id = '1422' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
207 0.0003 0.0003049373626709
SELECT * FROM products WHERE id = '2985'
208 0.0003 0.00031089782714844
SELECT * FROM productimages WHERE product_id = '2985' ORDER BY sortorder ASC
209 0.0004 0.00035905838012695
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2985' AND p.id = pi.product_id ORDER BY pi.sortorder
210 0.0007 0.00069308280944824
SELECT * FROM product_image_select WHERE product_id = '2985'
211 0.0003 0.00034713745117188
SELECT * FROM productcustomimages WHERE product_id = '2985'
212 0.0005 0.00047111511230469
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2985'
                GROUP BY o.product_id
213 0.0008 0.00080394744873047
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2985'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
214 0.0003 0.00034189224243164
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2985
215 0.0011 0.0011088848114014
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2985' AND a.name = n.originalname
216 0.0003 0.00025320053100586
SELECT * FROM productoffers WHERE product_id = '2985' AND merchantid = 'A1X6FK5RDHNB96'
217 0.0003 0.00031900405883789
SELECT * FROM productoffers
                WHERE product_id = '2985' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0002 0.00023293495178223
SELECT * FROM productoffers
                WHERE product_id = 2985
                ORDER BY price ASC LIMIT 1
219 0.0003 0.00029802322387695
SELECT value FROM productattributes
                WHERE product_id = '2985'
                AND name = 'ListPriceAmount'
220 0.0003 0.00026297569274902
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2985'
                GROUP BY o.product_id
221 0.0007 0.0007479190826416
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2985'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
222 0.0006 0.00055217742919922
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2985
223 0.0006 0.00055694580078125
SELECT value FROM productattributes WHERE product_id = '2985' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0003 0.00033116340637207
SELECT * FROM products WHERE parent_id = '2985'
225 0.0003 0.00028896331787109
SELECT * FROM products WHERE id = '4942'
226 0.0005 0.00050210952758789
SELECT * FROM productimages WHERE product_id = '4942' ORDER BY sortorder ASC
227 0.0007 0.00072789192199707
SELECT * FROM product_image_select WHERE product_id = '4942'
228 0.0003 0.0003361701965332
SELECT * FROM productcustomimages WHERE product_id = '4942'
229 0.0015 0.0015010833740234
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4942' AND a.name = n.originalname
230 0.0005 0.00049495697021484
SELECT * FROM productoffers WHERE product_id = '4942' AND merchantid = 'A1X6FK5RDHNB96'
231 0.0004 0.00036406517028809
SELECT * FROM productoffers
                WHERE product_id = '4942' AND price > 0
                ORDER BY price ASC LIMIT 1
232 0.0004 0.00043797492980957
SELECT value FROM productattributes WHERE product_id = '4942' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
233 0.0006 0.00055885314941406
SELECT * FROM products WHERE id = '1505'
234 0.0005 0.00053095817565918
SELECT * FROM productimages WHERE product_id = '1505' ORDER BY sortorder ASC
235 0.0008 0.00079178810119629
SELECT * FROM product_image_select WHERE product_id = '1505'
236 0.0004 0.00040292739868164
SELECT * FROM productcustomimages WHERE product_id = '1505'
237 0.0019 0.0019328594207764
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1505' AND a.name = n.originalname
238 0.0005 0.00046181678771973
SELECT * FROM productoffers WHERE product_id = '1505' AND merchantid = 'A1X6FK5RDHNB96'
239 0.0004 0.00036287307739258
SELECT * FROM productoffers
                WHERE product_id = '1505' AND price > 0
                ORDER BY price ASC LIMIT 1
240 0.0003 0.00029706954956055
SELECT * FROM productoffers
                WHERE product_id = 1505
                ORDER BY price ASC LIMIT 1
241 0.0003 0.0003349781036377
SELECT value FROM productattributes
                WHERE product_id = '1505'
                AND name = 'ListPriceAmount'
242 0.0003 0.00029802322387695
SELECT value FROM productattributes WHERE product_id = '1505' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0005 0.00050997734069824
SELECT * FROM products WHERE id = '2953'
244 0.0005 0.00054192543029785
SELECT * FROM productimages WHERE product_id = '2953' ORDER BY sortorder ASC
245 0.0008 0.00078296661376953
SELECT * FROM product_image_select WHERE product_id = '2953'
246 0.0005 0.00050592422485352
SELECT * FROM productcustomimages WHERE product_id = '2953'
247 0.0014 0.001417875289917
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2953' AND a.name = n.originalname
248 0.0008 0.00077319145202637
SELECT * FROM productoffers WHERE product_id = '2953' AND merchantid = 'A1X6FK5RDHNB96'
249 0.0004 0.00035905838012695
SELECT * FROM productoffers
                WHERE product_id = '2953' AND price > 0
                ORDER BY price ASC LIMIT 1
250 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '2953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251 0.0006 0.00057888031005859
SELECT * FROM products WHERE id = '2810'
252 0.0005 0.00051784515380859
SELECT * FROM productimages WHERE product_id = '2810' ORDER BY sortorder ASC
253 0.0003 0.0003359317779541
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2810' AND p.id = pi.product_id ORDER BY pi.sortorder
254 0.0007 0.00070595741271973
SELECT * FROM product_image_select WHERE product_id = '2810'
255 0.0004 0.00035905838012695
SELECT * FROM productcustomimages WHERE product_id = '2810'
256 0.0005 0.00048089027404785
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2810'
                GROUP BY o.product_id
257 0.0007 0.00070095062255859
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2810'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
258 0.0004 0.00037312507629395
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2810
259 0.0013 0.0012719631195068
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2810' AND a.name = n.originalname
260 0.0004 0.00035214424133301
SELECT * FROM productoffers WHERE product_id = '2810' AND merchantid = 'A1X6FK5RDHNB96'
261 0.0003 0.00032997131347656
SELECT * FROM productoffers
                WHERE product_id = '2810' AND price > 0
                ORDER BY price ASC LIMIT 1
262 0.0003 0.00026106834411621
SELECT * FROM productoffers
                WHERE product_id = 2810
                ORDER BY price ASC LIMIT 1
263 0.0003 0.00027990341186523
SELECT value FROM productattributes
                WHERE product_id = '2810'
                AND name = 'ListPriceAmount'
264 0.0004 0.00036311149597168
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2810'
                GROUP BY o.product_id
265 0.0007 0.0007169246673584
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2810'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
266 0.0004 0.00035214424133301
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2810
267 0.0005 0.00051498413085938
SELECT value FROM productattributes WHERE product_id = '2810' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
268 0.0003 0.00029110908508301
SELECT * FROM products WHERE parent_id = '2810'
269 0.0003 0.00034093856811523
SELECT * FROM products WHERE id = '4167'
270 0.0005 0.00051617622375488
SELECT * FROM productimages WHERE product_id = '4167' ORDER BY sortorder ASC
271 0.0003 0.00032997131347656
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4167' AND p.id = pi.product_id ORDER BY pi.sortorder
272 0.0009 0.00088000297546387
SELECT * FROM product_image_select WHERE product_id = '4167'
273 0.0003 0.00031208992004395
SELECT * FROM productcustomimages WHERE product_id = '4167'
274 0.0005 0.00050020217895508
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4167'
                GROUP BY o.product_id
275 0.0007 0.00068092346191406
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4167'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
276 0.0003 0.00032901763916016
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4167
277 0.0014 0.0013809204101562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4167' AND a.name = n.originalname
278 0.0002 0.00023317337036133
SELECT * FROM productoffers WHERE product_id = '4167' AND merchantid = 'A1X6FK5RDHNB96'
279 0.0003 0.00030398368835449
SELECT * FROM productoffers
                WHERE product_id = '4167' AND price > 0
                ORDER BY price ASC LIMIT 1
280 0.0003 0.00026106834411621
SELECT * FROM productoffers
                WHERE product_id = 4167
                ORDER BY price ASC LIMIT 1
281 0.0003 0.00031495094299316
SELECT value FROM productattributes
                WHERE product_id = '4167'
                AND name = 'ListPriceAmount'
282 0.0003 0.0002598762512207
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4167'
                GROUP BY o.product_id
283 0.0005 0.00053501129150391
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4167'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
284 0.0003 0.00026178359985352
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4167
285 0.0005 0.00053191184997559
SELECT value FROM productattributes WHERE product_id = '4167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
286 0.0003 0.00028896331787109
SELECT * FROM products WHERE parent_id = '4167'
287 0.0003 0.00025796890258789
SELECT * FROM products WHERE id = '4164'
288 0.0005 0.00047397613525391
SELECT * FROM productimages WHERE product_id = '4164' ORDER BY sortorder ASC
289 0.0005 0.00051212310791016
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4164' AND p.id = pi.product_id ORDER BY pi.sortorder
290 0.0008 0.00080513954162598
SELECT * FROM product_image_select WHERE product_id = '4164'
291 0.0005 0.00046491622924805
SELECT * FROM productcustomimages WHERE product_id = '4164'
292 0.0006 0.0005638599395752
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4164'
                GROUP BY o.product_id
293 0.0008 0.00083088874816895
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4164'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
294 0.0003 0.00032687187194824
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4164
295 0.0019 0.0019280910491943
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4164' AND a.name = n.originalname
296 0.0003 0.00026512145996094
SELECT * FROM productoffers WHERE product_id = '4164' AND merchantid = 'A1X6FK5RDHNB96'
297 0.0003 0.00026392936706543
SELECT * FROM productoffers
                WHERE product_id = '4164' AND price > 0
                ORDER BY price ASC LIMIT 1
298 0.0003 0.0002901554107666
SELECT * FROM productoffers
                WHERE product_id = 4164
                ORDER BY price ASC LIMIT 1
299 0.0003 0.0002598762512207
SELECT value FROM productattributes
                WHERE product_id = '4164'
                AND name = 'ListPriceAmount'
300 0.0005 0.00049591064453125
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4164'
                GROUP BY o.product_id
301 0.0009 0.00094294548034668
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4164'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
302 0.0003 0.00031304359436035
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4164
303 0.0005 0.00053501129150391
SELECT value FROM productattributes WHERE product_id = '4164' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
304 0.0006 0.00059294700622559
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4164'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
305 0.0003 0.00025606155395508
SELECT * FROM products WHERE id = '1089'
306 0.0005 0.0005180835723877
SELECT * FROM productimages WHERE product_id = '1089' ORDER BY sortorder ASC
307 0.0008 0.0008089542388916
SELECT * FROM product_image_select WHERE product_id = '1089'
308 0.0005 0.00050902366638184
SELECT * FROM productcustomimages WHERE product_id = '1089'
309 0.0014 0.0014069080352783
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1089' AND a.name = n.originalname
310 0.0008 0.00080990791320801
SELECT * FROM productoffers WHERE product_id = '1089' AND merchantid = 'A1X6FK5RDHNB96'
311 0.0003 0.00034093856811523
SELECT * FROM productoffers
                WHERE product_id = '1089' AND price > 0
                ORDER BY price ASC LIMIT 1
312 0.0004 0.0003511905670166
SELECT value FROM productattributes WHERE product_id = '1089' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
313 0.0019 0.0018560886383057
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2020' ORDER BY timestamp DESC
314 0.0003 0.00030994415283203
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1147' ORDER BY timestamp DESC
315 0.0003 0.00031614303588867
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '913' ORDER BY timestamp DESC
316 0.0003 0.00025200843811035
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2867' ORDER BY timestamp DESC
317 0.0002 0.00023984909057617
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1627' ORDER BY timestamp DESC
318 0.0003 0.00027298927307129
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3764' ORDER BY timestamp DESC
319 0.0003 0.00028395652770996
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3050' ORDER BY timestamp DESC
320 0.0002 0.0002439022064209
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4609' ORDER BY timestamp DESC
321 0.0002 0.00023984909057617
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1063' ORDER BY timestamp DESC
322 0.0003 0.00029492378234863
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1422' ORDER BY timestamp DESC
323 0.0003 0.00026106834411621
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2985' ORDER BY timestamp DESC
324 0.0002 0.0002448558807373
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4942' ORDER BY timestamp DESC
325 0.0003 0.0002598762512207
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1505' ORDER BY timestamp DESC
326 0.0003 0.00027990341186523
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2953' ORDER BY timestamp DESC
327 0.0003 0.0002739429473877
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2810' ORDER BY timestamp DESC
328 0.0003 0.00028419494628906
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4167' ORDER BY timestamp DESC
329 0.0003 0.00026392936706543
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4164' ORDER BY timestamp DESC
330 0.0003 0.00029301643371582
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1089' ORDER BY timestamp DESC
331 0.0016 0.0015509128570557
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
332 0.0014 0.0014488697052002
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
333 0.0004 0.00037884712219238
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
334 0.0253 0.025306224822998
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
335 0.0032 0.0032219886779785
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
336 0.0009 0.0008690357208252
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
337 0.0010 0.0010139942169189
SELECT * FROM products WHERE id = 1626
338 0.0005 0.00053906440734863
SELECT * FROM products WHERE id = 4041
339 0.0003 0.0002901554107666
SELECT * FROM products WHERE id = 4312
340 0.0003 0.00030279159545898
SELECT * FROM products WHERE id = 777
341 0.0003 0.00027108192443848
SELECT * FROM products WHERE id = 3881
342 0.0003 0.00028181076049805
SELECT * FROM products WHERE id = 4213
343 0.0003 0.00027990341186523
SELECT * FROM products WHERE id = '1626'
344 0.0005 0.00051283836364746
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
345 0.0011 0.0011060237884521
SELECT * FROM product_image_select WHERE product_id = '1626'
346 0.0005 0.00054597854614258
SELECT * FROM productcustomimages WHERE product_id = '1626'
347 0.0012 0.0011739730834961
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
348 0.0007 0.00065183639526367
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
349 0.0004 0.0003960132598877
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
350 0.0004 0.00041604042053223
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
351 0.0006 0.00063586235046387
SELECT * FROM products WHERE id = '4041'
352 0.0006 0.00055599212646484
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
353 0.0007 0.00073003768920898
SELECT * FROM product_image_select WHERE product_id = '4041'
354 0.0003 0.00030803680419922
SELECT * FROM productcustomimages WHERE product_id = '4041'
355 0.0012 0.0011739730834961
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
356 0.0004 0.00035285949707031
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
357 0.0003 0.00030279159545898
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
358 0.0005 0.00051999092102051
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
359 0.0007 0.00068497657775879
SELECT * FROM products WHERE id = '4312'
360 0.0006 0.00063586235046387
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
361 0.0010 0.00096297264099121
SELECT * FROM product_image_select WHERE product_id = '4312'
362 0.0006 0.00059986114501953
SELECT * FROM productcustomimages WHERE product_id = '4312'
363 0.0015 0.0014810562133789
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
364 0.0007 0.00066208839416504
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
365 0.0005 0.0004880428314209
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
366 0.0004 0.00039196014404297
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
367 0.0006 0.00058817863464355
SELECT * FROM products WHERE id = '777'
368 0.0005 0.00051188468933105
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
369 0.0008 0.00083208084106445
SELECT * FROM product_image_select WHERE product_id = '777'
370 0.0004 0.00037217140197754
SELECT * FROM productcustomimages WHERE product_id = '777'
371 0.0013 0.0012581348419189
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
372 0.0006 0.00055408477783203
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
373 0.0004 0.00038599967956543
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
374 0.0004 0.00037002563476562
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
375 0.0005 0.00048398971557617
SELECT * FROM products WHERE id = '3881'
376 0.0007 0.00065302848815918
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
377 0.0007 0.00069713592529297
SELECT * FROM product_image_select WHERE product_id = '3881'
378 0.0003 0.00031614303588867
SELECT * FROM productcustomimages WHERE product_id = '3881'
379 0.0011 0.0011458396911621
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
380 0.0005 0.00050783157348633
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
381 0.0004 0.00037693977355957
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
382 0.0004 0.00037598609924316
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
383 0.0005 0.00054502487182617
SELECT * FROM products WHERE id = '4213'
384 0.0006 0.00059199333190918
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
385 0.0008 0.00077199935913086
SELECT * FROM product_image_select WHERE product_id = '4213'
386 0.0004 0.00042581558227539
SELECT * FROM productcustomimages WHERE product_id = '4213'
387 0.0012 0.001230001449585
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
388 0.0006 0.00056314468383789
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
389 0.0004 0.00039005279541016
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
390 0.0004 0.00035715103149414
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
391 0.0024 0.0023899078369141
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
392 0.0008 0.00080394744873047
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
393 0.0029 0.0029361248016357
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
394 0.0019 0.0018870830535889
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
395 0.0006 0.00057601928710938
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
396 0.0005 0.00045490264892578
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
397 0.0005 0.00048184394836426
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'